Setup Microsoft SQL Server for SBC

This section describes the setup of the Microsoft SQL server for SBC device.

Do the following:
1. Run Microsoft SQL Server Management Studio.

A screenshot of a computer

Description automatically generated with medium confidence

2. Expand tables and select SysAdminTenant and dbo.ApplicationSetting, and then select Edit Top 200 Rows.
3. Add or edit the row with ID OvocSbcInfo to include the following SBC parameters:
Copy
-ipAddress: "xxx.xxx.xxx.xxx"
-name: "The SBC Name”, this will be the select region name you will select in step 3 - Voice Route Setting. Recommended name City/Region (e.g., “New Jersey, USA”)
 -“id":# (SBC ID Number from, e.g., “1”
-"sbcInfo"
-gatewayUser: SBC User Name (default = "Admin")
-gatewayPassword: SBC User Password (Default = "Admin")
4. Typical String:
Copy
[{"ipAddress":"x.x.x.x","name":"NewJersey,USA","id":3,"sbcInfo":{"gatewayUser":"Admin","gatewayPassword":"Admin"}},{"ipAddress":"x.x.x.x","name":"London,UK","id":4,"sbcInfo":{"gatewayUser":"Admin","gatewayPassword":"Admin"}}]

Graphical user interface, text, application, email

Description automatically generated